<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<title>Select list</title>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="generator" content="Doc-O-Matic" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <link rel="STYLESHEET" href="default.css" type="text/css" />

<script type="text/javascript" src="scripts.js"></script>
</head>
<body class="Element700" onload="onBodyLoadEx('frames.html', 'topic', 'Select_list.html');" onmousedown="onBodyMouseDown();">

<!-- Begin Popups -->

<!-- End Popups -->

<!-- Begin Page Header -->
<div class="Element710" id="areafixed">
<div class="Element94">
<em>You are here:</em> Using General SQL Parser &gt; <a href="Select_Statement.html" target="topic">Select Statement</a> &gt; <a href="Select_list.html" target="topic">Select list</a></div>
<div class="Element92">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="50%">
<div class="Element2">
<a href="contents.html" target="tocidx"><img src="btn_globals_contents_midblue.gif" border="0" alt="Contents" title="Contents" onmouseover="switchImage(this, 'btn_globals_contents_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_contents_midblue.gif');"></a><a href="idx.html" target="tocidx"><img src="btn_globals_index_midblue.gif" border="0" alt="Index" title="Index" onmouseover="switchImage(this, 'btn_globals_index_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_index_midblue.gif');"></a><a href="index.html" target="topic"><img src="btn_globals_home_midblue.gif" border="0" alt="Home" title="Home" onmouseover="switchImage(this, 'btn_globals_home_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_home_midblue.gif');"></a></div>
</td><td width="50%">
<div class="Element90">
<a href="From_clause.html" target="topic"><img src="btn_prev_midblue.gif" border="0" alt="Previous" title="Previous" onmouseover="switchImage(this, 'btn_prev_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_prev_midblue.gif');"></a><a href="Select_Statement.html" target="topic"><img src="btn_up_midblue.gif" border="0" alt="Up" title="Up" onmouseover="switchImage(this, 'btn_up_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_up_midblue.gif');"></a><a href="Where_clause.html" target="topic"><img src="btn_next_midblue.gif" border="0" alt="Next" title="Next" onmouseover="switchImage(this, 'btn_next_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_next_midblue.gif');"></a></div>
</td></tr></table><div class="Element5">
Select list</div>
</div>
</div>

<!-- End Page Header -->

<!-- Begin Client Area -->
<div class="Element720" id="areascroll">
<div class="Element721">

<!-- Begin Page Content -->
<div class="Element58">
<a name="Description"></a><div class="Element11">
<div class="Element10">
<p class="Element10">
Select list in select statement was represented by Fields which is type of <a href="TLzFieldList.html" target="topic">TLzFieldList</a>.&nbsp;</p>
<p class="Element10">
You can use SelectClauseText to fetch or set whole string value of select list, or iterate&nbsp;</p>
<p class="Element10">
Fields to handle each field separately.&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
Here are some key properties of <a href="TLzField.html" target="topic">TLzField</a>:&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
FieldType which is type of TLzFieldType
<ul class="Element633">
<li class="Element603">lftColumn: it represents a column information in create table statement. and following properties are valid only FieldType is lftColumn
<ol class="Element634">
<li value="1" class="Element604">ColumnName</li>
<li value="2" class="Element604">ComputedColumnExpr</li>
<li value="3" class="Element604">FieldDataType</li>
<li value="4" class="Element604">ColumnConstraints</li>
</ol></li>
<li class="Element603">lftAttr, check FieldAttr for field information</li>
<li class="Element603">lftExpression, field is an expression, check FieldExpr for detailed information.</li>
<li class="Element603">lftSubquery, field is a subquery, check subquery for more.</li>
</ul>&nbsp;</p>
<p class="Element10">
You can modify FieldName to change field.&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
aliasclause which is type <a href="TLz_AliasClause.html" target="topic">TLz_AliasClause</a> can be used to get or set alias information of field. if there is no aliasclause, and you need to add an alias to field, you have to create a new instance of <a href="TLz_AliasClause.html" target="topic">TLz_AliasClause</a>, and then set aliasclause.AsText to any valid string.&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
You can check following demos shipped together with this component to find out more information about how to work with fields in select list:
<ol class="Element633">
<li value="1" class="Element603">tablefieldrel</li>
</ol></p></div>
</div>
</div>
<!-- End Page Content -->

<!-- Begin Page Footer -->
<div class="Element93">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="100%">
<div class="Element3">
Gudu software http://www.sqlparser.com</div>
</td></tr><tr><td width="100%">
<div class="Element97">
Send <a href="#" onclick="sendFeedback('info@sqlparser.com', 'Documentation Feedback', 'Project: General SQL Parser Help file%0ATopic ID: Select list%0ATitle: Select list');">comments</a> about this topic.</div>
</td></tr></table></div>

<!-- End Page Footer -->
</div>
</div>

<!-- End Client Area -->
</body></html>